package cn.edu.cqut.mapper;

import cn.edu.cqut.entity.EcharsServeModel;
import cn.edu.cqut.entity.Serve;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author cqut-917371
 * @since 2020-06-24
 */
public interface ServeMapper extends BaseMapper<Serve> {
	@Select("select DATE_FORMAT(se_creatdate,'%Y') date, count(*) numbers, se_type type from serve GROUP BY DATE_FORMAT(se_creatdate,'%Y'), se_type")
	public List<EcharsServeModel> selectAllServe();
}